My SAS Enterprise Data Integration Server Review
The product is used by our company to meet specific needs in the analytics field, for our CRM. In our case, it's used to manage customer …
Overview
What is SAS Data Management?
A suite of solutions for data connectivity, enhanced transformations and robust governance. Solutions provide a unified view of data with access to data across databases, data warehouses and data lakes. Connects with cloud platforms, on-premises systems and multicloud data sources.
Recent Reviews
Awards
Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards
Popular Features
- Connect to traditional data sources (10)8.686%
- Connecto to Big Data and NoSQL (9)8.181%
- Integration with data quality tools (9)7.676%
- Simple transformations (8)6.161%
Features
Return to navigation
Product Details
- About
- Tech Details
- FAQs
What is SAS Data Management?
A suite of solutions for data connectivity, enhanced transformations and robust governance. Solutions provide a unified view of data with access to data across databases, data warehouses and data lakes. Connects with cloud platforms, on-premises systems and multicloud data sources.
Included Data Preparation solutions streamline data workflows and execute ELT, supporting data pipelines to ingest, transform and serve high-quality data with a low-code self-service visual designer. And governance solutions help users to ensure regulatory compliance.
SAS Data Management Technical Details
| Operating Systems | Unspecified |
|---|---|
| Mobile Application | No |
Frequently Asked Questions
A suite of solutions for data connectivity, enhanced transformations and robust governance. Solutions provide a unified view of data with access to data across databases, data warehouses and data lakes. Connects with cloud platforms, on-premises systems and multicloud data sources.
Reviewers rate Connect to traditional data sources highest, with a score of 8.6.
The most common users of SAS Data Management are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(36)Attribute Ratings
Reviews
(1-5 of 5)Companies can't remove reviews or game the system. Here's why
February 28, 2020
Easy to use Data Integration Software for Business Users
My organization is using the SAS Data Management Platform at an enterprise-level i.e., across multiple companies. The business problem was to have a single source of data for reporting and analysis as well as creating a 360-degree customer view to identify common customers across companies to improve cross-sell and up-sell. As there are multiple systems across multiple systems, a common data management platform was required to create an EDW for the same.
- Easy to use even for non-technical people
- Connects to a variety of data sources
- Statistical transformations available as part of the module
- Graphical drag & drop interface
- Requires third-party drivers to connect to common data sources like SFDC, MS SQL, Postgres.
- Debugging errors from the logs is a complicated process.
- E-mail alert system is very primitive and needs customization to make it more modern,
- Cannot send SMS alerts for jobs.
80%
8.0
90%
9.0
62.5%
6.3
85%
8.5
- The platform enabled us to have a single repository of customers to run campaigns on.
- Feedback from various campaigns is stored in a single database, which makes running A/B analysis easier.
- Helped improve data quality due to SAS Dataflux being a part of the SAS Data Management Platform.
- Informatica PowerCenter, IBM Netezza Data Warehouse Appliances and SQL Server Integration Services
SAS Data Management Platform requires third-party drivers to connect to common data sources like SFDC, MS SQL, Postgres. Has almost all features present as compared to the alternatives we evaluated. On top of it, SAS offered statistical transformations and strong metadata management. SAS Data Management Platform was also the most cost-effective solution despite having to purchase a couple of connectors for SAP and Salesforce. The easy of applying security templates was also a feature that can be easily used as compared to others mentioned.
This is used department-wide for different clients. There are very limited people who are using it because for handling this tool some experience is required. We use it to make data lakes for fetching data and using it for analyzing patterns.
- It can process multiple data sources together.
- It works very fast and is highly scalable.
- It hangs a lot, that means that while loading huge data it sometimes slows down.
- No modelling options available in the tool.
85%
8.5
90%
9.0
74%
7.4
75%
7.5
- It made life easy as many options are drag and drop. So work happens fast and ROI improved.
- We can use multiple data sources simultaneously for creation of the data. I think this also increases the ROI.
Because of ease of using SAS DI and data processing speed. There were lots of issues with AWS Redshift on cloud environment in terms of making connections with the data sources and while fetching the data we need to write complex queries.
June 04, 2019
A great product but licenses are costly
SAS has been used by many users in our organization, mainly business and retail users for running various modeling using SAS optimizer. It allows the user a wider range of capabilities to cleanse and manipulate the data.
- Manipulation of data
- Interact directly with visualizations that refine analyses
- Wide range of delivery reports
- Licenses are very costly
- Its not easy to move SAS users to other open source products because of the easy programming in SAS.
100%
10.0
100%
10.0
92%
9.2
90%
9.0
- We looked at how this tool could not only help us now but what it can do to expand our business intelligence in the future.SAS is great because they have so many different modules and products that a company can simply add capabilities as they grow their internal business intelligence division.
SAS integration is not easy because there are various PAM related modules which require additional vendor involvement. Overall once all integrations are set up, it's a great tool and provides multiple options to users for running their model.
170
Retail, Business, Finance users
3
SAS Administration is a must along with Unix experience.
- Data modelling
- Data governance
- Data optimizer
- Evaluate other alternatives to avoid license cost
They have funded the SAS upgrade project last year.
- SAS programming
- API calls
- Integration with warehouse and big data
- Encryption
- Data governance
February 28, 2018
Trustworthy and Powerful
SAS Data Integration Studio is being used for one view of all our data across the organization. Pulling from our Oracle and SQL Servers the data is described in a fashion that users can know what they are looking at with only a little bit of effort. It also pulls from our major vendors' platforms, pulling both the data or metadata from their systems.
- With SAS Data Integration Studio it doesn't matter to users where the data is originally from it all is presented in a consistent manner.
- The SAS Data Integration Studio is fairly reliable it usually works well.
- The visual design of reports our users even describe as fun.
- Sometimes parts of the data are not available, although this is generally because it is connected to so many different systems.
- Price, it's not the cheapest software, however the value for dollars spent does seem to be good.
- Sometimes all the different systems and platforms and folders and so forth get a bit overwhelming for new users.
100%
10.0
90%
9.0
80%
8.0
90%
9.0
- We have more users who can connect to the many different data sources.
- Our users do have existing SAS programming knowledge and that can carry over.
- Business functions are starting to rely on SAS Data Integration Studio work product shortly after introduction.
- Base SAS and Microsoft Systems Management Server
Because SAS Data Integration Studio is the third party it seems to work equally well with all our systems. That is to say that it doesn't really work better with Microsoft or Oracle but really just seems to work equally well with all of them. It has a very powerful back-end that allows us to transform and load our data quickly and efficiently programmer time wise.
February 22, 2018
SAS/ACCESS is a must for the every day SAS data analyst.
SAS/Access is used by my main customer as an efficient way of bringing data from the enterprise data warehouse into SAS for crunching and general customer insight work. It's also used in some cases to reinject data into the warehouse so that people using other BI tools can access it. Using SAS for statistical analysis as well as an ETL tool allows the users to kill two birds with one stone. They can extract the data themselves and then transform it like they want.
The SAS users are located in several business units with the main ones being risk and marketing. For marketing, it's a question of getting data from several different platforms in order to get a clear customer picture. For risk, it's also about getting data from several platforms but the purpose is to size the risk associated with actual and future loans.
The SAS users are located in several business units with the main ones being risk and marketing. For marketing, it's a question of getting data from several different platforms in order to get a clear customer picture. For risk, it's also about getting data from several platforms but the purpose is to size the risk associated with actual and future loans.
- SAS supports the main database connection options that allow you to optimize the performance of your extracts and loads.
- Simplicity of the syntax for a basic connection.
- Ability to configure by an administrator in a BI environment so that all users can benefit from the connection without having to establish it by themselves.
- Easier management in the administration platform. Connecting these can be a challenge.
90%
9.0
90%
9.0
70%
7.0
40%
4.0
- Hard to say because it's a part of a global solution. Definetaly help reduce cost by allowing users to use only one tool and not 2.
- Datastage
Datastage might be the closest one. Being a full ETL tool, it's weird to compare both. Datastage might be more robust for extraction but it lacks the simplicity that the end users need for everyday data extract and analysis.